package zyc.dao;

import zyc.pojo.Page;
import zyc.pojo.Student;

import java.lang.reflect.Method;
import java.util.List;

/**
 * @description: 管理学生数据Dao层
 * @author: Code-zyc
 * @date: Created in 2020/12/21 9:53
 * @version: v1.0
 * @modified By:
 */
public interface StudentDao {

    /**
     * @descript :获取所有的student
     * @author :ZhaoYicong
     * @date :2020/12/21 13:38
     * @Param: null
     * @return :
     * @throws :
     * @since :
     */

    List<Student> getallstudents(Page page);
    /**
     * @descript : 按照id来查询对应student
     * @author :ZhaoYicong
     * @date :2020/12/21 13:38
     * @Param: id
     * @return :
     * @throws :
     * @since :
     */

    Student getstudentByid(Integer id);

    void deletByid(Integer id);

    void updatestudent(Student student);

    void creatStudent(Student student);

    Integer getCount();

    Student getstudentBysid(Integer sid);

    List<Student> getstudentsByname(String name);

    List<Student> getstudentsBymath(Double math);

    List<Student> getstudentsByAsc(String type);

    List<Student> getstudentsByDesc(String type);

    Student getstudentBySidPass(Integer sid, String password);
}
